Aside

Data Tools & Languages

Data Management & Analysis Skills

Education

Double Bachelor of Arts in
Psychology & Philosophy

Victoria University of
Wellington

November, 2019

Wellington, NZ

Certification

Professional Certificate in Data Analytics

Google Careers Certification

June, 2021

Coursera

Disclaimer

Page 1 of 1

Main

Kyle PATRICK Simpson

Data Pipeline Support Specialist   |   Research Analyst   |   Data Stakeholder Liason

A results-driven professional with over 5 years specializing in data analytics and pipeline support, proficient in SQL, Python, R, and VBA in Excel for data wrangling, automation, and reporting. Confidently combines analytics with strong interpersonal acumen, administrative efficiency, and a proven ability to quickly secure, validate, and analyze complex data types.

Relevant Work History

Inventory & Quality Assurance Analyst

M2 by Matcha Matcha

Toronto, Ont

2024

  • Developed an accurate inventory reporting system using R, SQL, and Excel/Google Sheets via triangulation of sales, purchasing, and inventory records.
  • Maintained relational database of supplier, product, and customer information acquired via information requests, exported datasets, APIs, and web-scraping.
  • Facilitated working relationships with suppliers to ensure consistency of quality, supply, and pricing.

Data Migration Technician

Lions Foundation of Canada Dog Guides

Oakville, Ont

2022

  • Consulted on migration of 4 months financial and client data from Excel & Quickbooks into Salesforce.
  • Creation of automated workflows using VBA in Excel for the purpose of data compiling, cleaning, and validation.
  • Reached out to individual donor and/or members of the finance team to amend irregularities and/or obtain missing data as required.

Lodgement Administrator

Accident Compensation Commission, NZ

Dunedin, NZ

2022 - 2021

  • Demonstrated ability to quickly learn NZ health care policy as it pertains to various work environments and accident coverage.
  • Researched and identified various employer entities to ensure accurate attribution of benefits.
  • Employed analytical skills to proactively identify and resolve system irregularities and errors.

Managing Director

Bar Squire Beverage Consultancy Services

Wellington, NZ

2021 - 2020

  • Provided data driven consultation to bars, restaurants, and events.
  • Creation and maintenance of relational databases containing client information, cocktail recipes, product information, bar & restaurant points of service.
  • Use of SQL, Excel, R, and Python to wrangle data.

Research Analyst

Greenback Ltd.

Auckland, NZ

2020 - 2019

  • Conducted thorough literature reviews of various subjects so as to educate myself and team members on relevant subject matter, data types, and stakeholders.
  • Identified various sources of private and publicly available environmental data via information requests, web-scraping, and API pulls.
  • Collaborated directly with the application development team on data implementation and structuring.